When you install iMIS Analytics, the setup program creates a scheduled Integration Services package named Update instanceName_analysisDBName on the Analytics server host. The package extracts data from the iMIS database, updates the Analytics data warehouse, and updates the Analytics cubes.
The package is scheduled by default to run every night at 4:00 a.m. server time, but you can modify the schedule by using the procedure described in Changing the scheduled run time of the Update i15Analytics package.
You might occasionally need to manually execute this package during the business day, such as after first installing Analytics (to populate the data warehouse and cubes), or when configuring Analytics to track custom iMIS 10 demographics (see Configuring Analytics to track custom iMIS demographics).
Before you begin
Analytics must be properly installed and configured. See Installing Analytics for more information.
Note: Depending on the size of your iMIS database, this process can take a long time to complete.
To manually run the Update i15Analytics package
1. Using Microsoft SQL Server Management Studio, connect to the Database Engine on the Analytics host.
2. In the Object Explorer pane, browse to SQL Server Agent > Jobs.
The Summary Page displays the scheduled jobs on the Analytics host.
3. Right-click the Update instanceName_analysisDBName job and choose Start Job at Step.
The Start Jobs window appears and displays status while it runs the job. When the job has completed successfully, the Start Jobs window displays a success message.
Troubleshooting issues with the Update i15Analytics package
If the facts in the iMIS cube have no data or if the data does not match the contents of the data warehouse after running the Update i15Analytics package (evidenced by the Briefing Book showing no data or incorrect or old data), you must run two stored procedures to fix the problem. This needs to be done only once.
1. Using Microsoft SQL Server Management Studio, connect to the Database Engine on the Analytics host.
2. Use the query window to execute the following two stored procedures, with the listed parameters:
exec asi_dwSetLAll 1
exec asi_DWSInitDB
3. Re-run the Update i15Analytics package.